KS_BASE_PRICES
Ordinal
|
Description
|
Data Type
|
Data Length
|
Required
|
Check
Constraints
|
Comments
|
1
|
Item ID
|
string
|
25
|
Y
|
|
|
2
|
Price Sheet Code
|
string
|
30
|
|
|
This
field is used to identify a unique price sheet. Customer locations are
associated to a default price sheet in the storefront so base pricing can be
determined. If this is left blank, then the overall Price Sheet for the store
is used or Price Matrices may explicitly set the Price Sheet to use.
Examples: USA, STOREnn, BRANCHnn
|
3
|
Base Price
|
money
|
|
Y
|
|
This
is the base price for this item and price list. The storefront starts with
this number then applies any markups or discounts defined. This is also
referred to as list price.
|
4
|
Price Basis Code
|
string
|
30
|
|
|
This
field is a secondary filter to Price Sheet to determine customer specific
pricing. Examples: LIST, MSRP, WHOLESALE, RETAIL, COST)
|
5
|
Start Date
|
date
|
|
|
Must be a proper date
|
Defines
when this price will be in effect. Can be left blank which means effective
now until a future date is reached that activates a new price entry.
|
|